-- 2012-05-17 EM .

alter procedure sp_login_special
	@phone varchar(21),
	@logon varchar(50) output,
	@xml xml output,
	@sid uniqueidentifier output
as
begin
	set nocount on;
declare
@result varchar(160),
@Identificator_id bigint 	

exec sms_p.dbo.prints 'LSP 000','sp_login_special:', @phone,32

exec dbproc.dbo.sp_get_special_rights @Phone, @logon output, @identificator_id output, @Result output


--exec dbproc.dbo.sp_open_session_by_phone @phone, @xml output, @sid output;

exec sms_p.dbo.prints 'LSP 017','session :', @sid,32
/*	
	if @sid is null
		return
	else
		begin
		end
*/

end;
go

grant execute on sp_login_special to Executer;